home *** CD-ROM | disk | FTP | other *** search
/ Visual Cafe 3 / Visual Cafe 3.ISO / Vcafe / Sample.bin / CreateSuppliers.java < prev    next >
Text File  |  1998-06-30  |  1KB  |  56 lines
  1.  
  2. import java.net.URL;
  3. import java.sql.*;
  4.      
  5. public class CreateSuppliers {
  6.  
  7.     public static void main(String args[]) {
  8.         String url = "jdbc:sybase://dbtest:1455/spring";
  9.         Connection con;
  10.         String createString;
  11.  
  12.       /*****************
  13.       DataTable dt = new JDBCAdapter(
  14.             "jdbc:sybase://dbtest:1455/spring",
  15.             // "SELECT * FROM test",
  16.             "SELECT * FROM COFFEES",
  17.             "connect.sybase.SybaseDriver",
  18.             "guest",
  19.             "trustworthy");
  20.       ****************************/
  21.  
  22.  
  23.         createString = "create table SUPPLIERS " + 
  24.                         "(SUP_ID int, " +
  25.                         "SUP_NAME varchar(40), " +
  26.                         "STREET varchar(40), " +
  27.                         "CITY varchar(20), " +
  28.                         "STATE char(2), ZIP char(5))";
  29.     
  30.         Statement stmt;
  31.     
  32.         try {
  33.             Class.forName("connect.sybase.SybaseDriver");
  34.  
  35.         } catch(java.lang.ClassNotFoundException e) {
  36.             System.err.print("ClassNotFoundException: "); 
  37.             System.err.println(e.getMessage());
  38.         }
  39.  
  40.         try {
  41.             con = DriverManager.getConnection(url, 
  42.                                      "guest", "trustworthy");
  43.     
  44.             stmt = con.createStatement();                            
  45.                stmt.executeUpdate(createString);
  46.     
  47.             stmt.close();
  48.             con.close();
  49.     
  50.         } catch(SQLException ex) {
  51.             System.err.println("SQLException: " + ex.getMessage());
  52.         }
  53.     }
  54. }
  55.  
  56.